{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["PLAN DE TRABAJO","PROGRAMA DE CAPACITACIONES PESV","INDICADORES PESV","MATRIZ DE OBJETIVOSINDICADORES","INDICADORES MTO","ESTADISTICAS SINIESTROS","CARACTERIZACIÓN"],"not_rendered":{"charts":24,"images":3,"macros":1,"external_links":72,"defined_names":2484,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PLAN DE TRABAJO","index":0,"n_rows":68,"n_cols":253,"rows_kept":68,"cut":false,"hidden":false,"merged":[[66,2,66,13],[66,14,66,31],[67,2,67,13],[67,14,67,31],[61,29,61,30],[64,2,64,13],[64,14,64,31],[65,2,65,13],[65,14,65,31],[51,1,51,31],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[61,15,61,16],[61,17,61,18],[61,19,61,20],[61,21,61,22],[61,23,61,24],[61,25,61,26],[61,27,61,28],[5,5,6,31],[8,32,10,32],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,9,6],[9,7,9,8],[9,21,9,22],[9,23,9,24],[9,25,9,26],[9,27,9,28],[9,3,10,3],[9,9,9,10],[12,1,12,31],[28,1,28,31],[1,1,3,2],[1,29,1,31],[2,29,2,31],[8,5,8,28],[8,29,9,31],[11,1,11,31],[9,19,9,20],[3,3,3,31],[9,11,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[1,3,2,28],[5,1,6,4]]}
[" "]
[null,{"$error":"#VALUE!"},null,"PLAN ESTRATÉGICO DE SEGURIDAD VIAL"]
[]
[null,null,null,"PLAN DE TRABAJO ANUAL"]
[]
[null,"OBJETIVO: ",null,null,null,"META: "]
[]
[]
[null,null,null,null,null,"AÑO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consolidado",null,null,"OBSERVACIONES"]
[null,"N.º","CRONOGRAMA DE ACTIVIDADES ","PRESUPUESTO","RESPONSABLE","ENE",null,"FEB",null,"MAR",null,"ABR",null,"MAY",null,"JUN",null,"JUL",null,"AGO",null,"SEP",null,"OCT",null,"NOV",null,"DIC"]
[null,null,null,null,null,"P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","Cumplimiento"]
[]
[null,"PLANEAR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HACER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"º"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"VERIFICAR"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total Actividades"]
[null,null,null,null,"Cumplimiento"]
[]
[]
[null,null,"ENCARGADO PESV"]
[]
[null,null,"FECHA: "]
[null,null,"FIRMA: "]

{"sheet":"PROGRAMA DE CAPACITACIONES PESV","index":1,"n_rows":121,"n_cols":41,"rows_kept":121,"cut":false,"hidden":false,"merged":[[110,0,110,24],[112,0,112,2],[112,18,112,19],[18,1,18,8],[18,9,18,10],[31,40,32,40],[31,38,32,38],[31,37,32,37],[10,0,10,40],[11,40,12,40],[94,27,94,28],[88,0,88,30],[89,0,89,30],[90,27,90,28],[90,29,90,30],[91,0,91,14],[91,15,91,24],[91,25,91,26],[91,27,91,28],[92,0,92,14],[92,15,92,24],[92,25,92,26],[92,27,92,28],[90,25,90,26],[124,0,124,14],[124,15,124,24],[124,25,124,26],[124,27,124,28],[118,0,118,30],[119,0,119,30],[120,27,120,28],[120,29,120,30],[121,0,121,14],[121,15,121,24],[121,25,121,26],[121,27,121,28],[122,0,122,14],[122,15,122,24],[122,25,122,26],[122,27,122,28],[120,25,120,26],[120,0,120,14],[120,15,120,24],[123,0,123,14],[123,15,123,24],[123,25,123,26],[123,27,123,28],[90,0,90,14],[90,15,90,24],[93,0,93,14],[93,15,93,24],[93,25,93,26],[12,29,12,30],[20,1,20,8],[20,9,20,10],[15,9,15,10],[16,1,16,8],[16,9,16,10],[17,1,17,8],[17,9,17,10],[30,1,30,8],[30,9,30,10],[28,1,28,8],[28,9,28,10],[23,1,23,8],[23,9,23,10],[24,1,24,8],[24,9,24,10],[25,1,25,8],[25,9,25,10],[26,1,26,8],[12,31,12,32],[11,11,13,11],[11,12,13,12],[62,15,62,24],[63,0,63,14],[63,15,63,24],[93,27,93,28],[75,1,75,26],[77,0,77,24],[66,0,68,0],[66,1,66,26],[12,25,12,26],[14,0,30,0],[14,1,14,8],[14,9,14,10],[15,1,15,8],[21,1,21,8],[21,9,21,10],[22,1,22,8],[22,9,22,10],[19,1,19,8],[19,9,19,10],[27,1,27,8],[27,9,27,10],[4,29,4,35],[4,36,4,39],[0,0,2,4],[0,5,1,34],[0,35,0,39],[1,35,1,39],[2,5,2,34],[2,35,2,39],[8,0,8,9],[8,10,8,28],[8,29,8,39],[4,0,4,4],[4,5,4,8],[4,9,4,23],[4,24,4,28],[5,0,7,4],[5,5,5,8],[5,9,5,23],[5,24,5,28],[5,29,5,35],[5,36,5,39],[6,5,6,8],[6,9,6,23],[6,24,6,28],[6,29,6,35],[12,21,12,22],[12,23,12,24],[9,29,9,39],[6,36,6,39],[7,5,7,8],[7,9,7,23],[7,24,7,28],[7,29,7,35],[7,36,7,39],[9,0,9,9],[9,10,9,28],[11,0,13,8],[11,9,13,10],[11,13,11,24],[11,25,11,36],[11,37,12,39],[12,13,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,33,12,34],[12,35,12,36],[12,27,12,28],[26,9,26,10],[32,25,32,26],[32,27,32,28],[32,29,32,30],[32,31,32,32],[32,33,32,34],[29,1,29,8],[29,9,29,10],[32,35,32,36],[32,13,32,14],[32,15,32,16],[32,17,32,18],[32,19,32,20],[32,21,32,22],[32,23,32,24],[41,1,41,26],[42,1,42,26],[43,1,43,26],[44,1,44,26],[45,1,45,26],[47,0,47,24],[36,0,38,0],[36,1,36,26],[37,1,37,26],[38,1,38,26],[39,1,39,26],[40,1,40,26],[52,0,52,2],[52,18,52,19],[52,20,52,21],[52,22,52,23],[53,0,53,2],[53,18,53,19],[53,20,53,21],[53,22,53,23],[48,1,48,4],[48,5,48,18],[48,19,49,19],[49,1,49,4],[49,5,49,18],[50,0,50,24],[56,0,56,2],[56,18,56,19],[56,20,56,21],[56,22,56,23],[54,0,54,2],[54,18,54,19],[54,20,54,21],[54,22,54,23],[55,0,55,2],[55,18,55,19],[55,20,55,21],[55,22,55,23],[58,0,58,30],[60,25,60,26],[60,27,60,28],[60,29,60,30],[64,25,64,26],[71,1,71,26],[72,1,72,26],[73,1,73,26],[74,1,74,26],[64,0,64,14],[64,15,64,24],[61,27,61,28],[62,27,62,28],[63,27,63,28],[64,27,64,28],[59,8,59,30],[63,25,63,26],[61,25,61,26],[62,25,62,26],[60,0,60,14],[60,15,60,24],[61,0,61,14],[61,15,61,24],[62,0,62,14],[67,1,67,26],[68,1,68,26],[69,1,69,26],[70,1,70,26],[82,0,82,2],[82,18,82,19],[82,20,82,21],[82,22,82,23],[83,0,83,2],[83,18,83,19],[83,20,83,21],[83,22,83,23],[78,1,78,4],[78,5,78,18],[78,19,79,19],[79,1,79,4],[79,5,79,18],[80,0,80,24],[86,0,86,2],[86,18,86,19],[86,20,86,21],[86,22,86,23],[84,0,84,2],[84,18,84,19],[84,20,84,21],[84,22,84,23],[85,0,85,2],[85,18,85,19],[85,20,85,21],[85,22,85,23],[94,0,94,14],[94,15,94,24],[94,25,94,26],[105,1,105,26],[107,0,107,24],[108,1,108,4],[108,5,108,18],[108,19,109,19],[109,1,109,4],[109,5,109,18],[99,1,99,26],[100,1,100,26],[101,1,101,26],[102,1,102,26],[103,1,103,26],[104,1,104,26],[97,1,97,26],[98,1,98,26],[96,0,98,0],[96,1,96,26],[112,20,112,21],[112,22,112,23],[113,0,113,2],[113,18,113,19],[113,20,113,21],[113,22,113,23],[116,0,116,2],[116,18,116,19],[116,20,116,21],[116,22,116,23],[114,0,114,2],[114,18,114,19],[114,20,114,21],[114,22,114,23],[115,0,115,2],[115,18,115,19],[115,20,115,21],[115,22,115,23]]}
[null,null,null,null,null,"PLAN ESTRATEGICO DE SEGURIDAD VIAL"]
[]
[null,null,null,null,null,"PROGRAMA DE CAPACITACIONES"]
[]
["OBJETIVO",null,null,null,null,"NOMBRE DEL INDICADOR ",null,null,null,"FÓRMULA DEL INDICADOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESPONSABLE ",null,null,null,null,"META",null,null,null,null,null,null,"FRECUENCIA"]
["Prevenir la ocurrencia de accidentes y enfermedades laborales asociados a las actividades de la compañía por medio de capacitaciones.",null,null,null,null,"Cumplimiento",null,null,null,"No. de Actividades Ejecutadas / No. de Actividades Programadas x 100%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SST",null,null,null,null,"90% de las actividades programadas",null,null,null,null,null,null,"TRIMESTRAL"]
[null,null,null,null,null,"Cobertura",null,null,null,"No. De trabajadores que participan en la actividad  /No. De trabajadores programados  x 100%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SST",null,null,null,null,"80% de los trabajadores programados",null,null,null,null,null,null,"TRIMESTRAL"]
[null,null,null,null,null,"Eficacia",null,null,null,"Número de evaluaciones eficaces / Número de personas evaluadas  x 100%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SST",null,null,null,null,"Generar el cierre del 90% de los hallazgos encontrados ",null,null,null,null,null,null,"TRIMESTRAL"]
["ALCANCE ",null,null,null,null,null,null,null,null,null,"RECURSOS NECESARIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOCUMENTOS REFERENCIA "]
["Este programa aplica para todos los trabajadores de la organizaciòn",null,null,null,null,null,null,null,null,null,"Económicos, Técnicos, Humanos, Infraestructura ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legislación Aplicable "]
["CRONOGRAMA DE ACTIVIDADES"]
["ACTIVIDADES",null,null,null,null,null,null,null,null,"Responsable ",null,"RECURSOS","HORAS","SEMESTRE I",null,null,null,null,null,null,null,null,null,null,null,"SEMESTRE II",null,null,null,null,null,null,null,null,null,null,null,"Consolidado",null,null,"SEGUIMIENTO AL CUMPLIMIENTO DEL CRONOGRAMA "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ENE",null,"FEB",null,"MAR",null,"ABR",null,"MAY",null,"JUN",null,"JUL",null,"AGO.",null,"SEP.",null,"OCT",null,"NOV",null,"DIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","%","OBSERVACIONES SEGUIMIENTO "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N15+P15+R15+T15+V15+X15+Z15+AB15+AD15+AF15+AH15+AJ15","v":0},0,{"$f":"IFERROR(AM15/AL15,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IFERROR(AM24/AL24,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N26+P26+R26+T26+V26+X26+Z26+AB26+AD26+AF26+AH26+AJ26","v":0},0,{"$f":"IFERROR(AM26/AL26,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IFERROR(AM27/AL27,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IFERROR(AM28/AL28,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N31+P31+R31+T31+V31+X31+Z31+AB31+AD31+AF31+AH31+AJ31","v":0},{"$f":"O31+Q31+S31+U31+W31+Y31+AA31+AC31+AE31+AG31+AI31+AK31","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(N15:N31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL15:AL31)","v":0},{"$f":"SUM(AM15:AM31)","v":0},"","CUMPLIMIENTO "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ENE",null,"FEB",null,"MAR",null,"ABR",null,"MAY",null,"JUN",null,"JUL",null,"AGO.",null,"SEP.",null,"OCT",null,"NOV",null,"DIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E"]
[]
[]
["Indicador 1","PROGRAMA DE CAPACITACIONES"]
[null,"FICHA TÉCNICA INDICADORES"]
[null,"SUPERINTENDENCIA DE INDUSTRIA Y COMERCIO "]
["NOMBRE","Cumplimiento "]
["INTERPRETACIÓN","Cumplimiento de Actividades en el programas "]
["FACTOR QUE MIDE","Cumplimiento   "]
["PERIODICIDAD DEL REPORTE","Semestral se revisará el avance del indicador con Actividades ejecutadas dentro del cronograma"]
["FUENTE DE LA INFORMACIÓN","plan de trabajo"]
["RESPONSABLE","SST"]
["PERSONAS QUE DEBEN CONOCER","COMITÉ VIAL -ALTA GERENCIA- DTH-COPASST"]
[]
["FÓRMULA"]
[null,"Numerador",null,null,null,"No. De Actividades realizadas",null,null,null,null,null,null,null,null,null,null,null,null,null,"x 100"]
[null,"Denominador",null,null,null,"No. De actividades programadas"]
["VALORES DEL PERIODO"]
[]
["PERIODO",null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
["No. De Actividades ejecutadas"]
["No. De actividades programadas"]
["META < 90"]
["VALOR DEL INDICADOR %",null,null,{"$f":"IFERROR(D54/D55,\"\")","v":""},"","","","","","","",{"$f":"IFERROR(L54/L55,\"\")","v":""},{"$f":"IFERROR(M54/M55,\"\")","v":""},{"$f":"IFERROR(N54/N55,\"\")","v":""},{"$f":"IFERROR(O54/O55,\"\")","v":""}]
[]
["ANÁLISIS TENDENCIAL "]
[]
["ANÁLISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan de Acción ",null,null,null,null,null,null,null,null,null,"Plazo",null,"Responsable",null,"Acción correctiva?"]
[]
[]
[]
[]
[]
["Indicador 2"]
[null,"FICHA TÉCNICA INDICADORES"]
[null,"SUPERINTENDENCIA DE INDUSTRIA Y COMERCIO "]
["NOMBRE","Indicador de Cobertura "]
["INTERPRETACIÓN","Cobertura de los trabajadores en el programa"]
["FACTOR QUE MIDE","Cobertura   "]
["PERIODICIDAD DEL REPORTE","Semestral se revisará el avance del indicador con Actividades ejecutadas dentro del cronograma"]
["FUENTE DE LA INFORMACIÓN","plan de trabajo"]
["RESPONSABLE","SST"]
["PERSONAS QUE DEBEN CONOCER","Alta gerencia- DTH-COPASST"]
[]
["FÓRMULA"]
[null,"Numerador",null,null,null,"No. Trabajadores que participaron de las actividades",null,null,null,null,null,null,null,null,null,null,null,null,null,"x 100"]
[null,"Denominador",null,null,null,"No. De Trabajadores programados"]
["VALORES DEL PERIODO"]
[]
["PERIODO",null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
["NUMERADOR"]
["DENOMINADOR"]
["META < 80"]
["VALOR DEL INDICADOR %"]
[]
["ANÁLISIS TENDENCIAL PRIMER SEMESTRE"]
[]
["ANÁLISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan de Acción ",null,null,null,null,null,null,null,null,null,"Plazo",null,"Responsable",null,"Acción correctiva?"]
[]
[]
[]
[]
[]
["Indicador 3","PROGRAMA DE CAPACITACIONES"]
[null,"FICHA TÉCNICA INDICADORES"]
[null,"SUPERINTENDENCIA DE INDUSTRIA Y COMERCIO "]
["NOMBRE","Eficacia"]
["INTERPRETACIÓN","Eficacia de los planes de acciòn propuesttos"]
["FACTOR QUE MIDE","Eficacia"]
["PERIODICIDAD DEL REPORTE","Semestral se revisará el avance del indicador con Actividades ejecutadas dentro del cronograma"]
["FUENTE DE LA INFORMACIÓN","plan de trabajo"]
["RESPONSABLE","SST"]
["PERSONAS QUE DEBEN CONOCER","Alta gerencia- DTH-COPASST"]
[]
["FÓRMULA"]
[null,"Numerador",null,null,null,"Número de evaluaciones eficaces ",null,null,null,null,null,null,null,null,null,null,null,null,null,"x 100"]
[null,"Denominador",null,null,null," Número de personas evaluadas"]
["VALORES DEL PERIODO"]
[]
["PERIODO",null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
["NUMERADOR"]
["DENOMINADOR"]
["META < 90"]
["VALOR DEL INDICADOR %"]
[]
["ANÁLISIS TENDENCIAL PRIMER SEMESTRE"]
[]
["ANÁLISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan de Acción ",null,null,null,null,null,null,null,null,null,"Plazo",null,"Responsable",null,"Acción correctiva?"]

{"sheet":"INDICADORES PESV","index":2,"n_rows":136,"n_cols":38,"rows_kept":136,"cut":false,"hidden":false,"merged":[[0,7,4,13],[25,2,40,6],[25,7,26,10],[25,12,40,17],[25,18,26,22],[46,1,61,6],[46,7,47,10],[46,12,61,17],[46,18,47,22],[46,31,61,36],[25,37,26,40],[27,7,40,10],[27,18,40,22],[27,37,40,40],[45,31,45,32],[25,26,40,36],[46,37,47,40],[48,7,61,10],[48,18,61,22],[48,37,48,38],[49,37,54,40],[55,37,55,38],[56,37,61,40],[67,1,82,6],[67,7,68,10],[67,18,68,22],[67,26,82,36],[67,37,68,40],[69,7,82,10],[69,18,82,22],[69,37,82,40],[89,18,90,22],[89,26,104,36],[89,37,90,40],[91,7,104,10],[91,18,104,22],[91,37,104,40],[133,26,148,36],[133,37,134,40],[135,37,148,40],[0,0,4,6],[111,1,126,6],[111,7,112,10],[111,12,126,17],[111,18,112,22],[111,26,126,36],[111,37,112,40],[113,7,126,10],[113,18,126,22],[113,37,126,40],[89,1,104,6],[89,7,90,10],[89,12,104,17]]}
[{"$error":"#VALUE!"},null,null,null,null,null,null,"INDICADORES PESV"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicador 1",null,"Indicador 2","Indicador 3","Indicador 3.1","Indicador 4","Indicador 5","META","Indicador 6","META","Indicador 7","META","Indicador 8","META","Indicador 9","META","Indicador 10","META","Indicador 11","META","Indicador 12","META","Indicador 13","META"]
[null,null,"AÑO","# TRABAJADORES","# TOTAL DE DIAS TRABAJADOS","SINIESTROS VIALES SIN DIAS DE INCAPACIDAD ","SINIESTROS VIALES CON DIAS DE INCAPACIDAD","SINIESTROS VIALES MORTALES","TOTAL DE SINIESTROS VIALES (SV)","DIAS DE INCAPACIDAD POR SINIESTROS VIALES","INDICE DE FRECUENCIA","INDICE DE SEVERIDAD","PROPORCIÓN DE ACCIDENTES MORTALES","KMS","indicador 1","META","indicador 2","indicador 3","indicador 3.1","indicador 4","Indicador 5","META2","Indicador 6","META3","Indicador 7","META4","Indicador 8","META5","Indicador 9","META6","Indicador 10","META7","Indicador 11","META8","Indicador 12","META9","Indicador 13","META10"]
[null,null,"ENERO"]
[null,null,"FEBRERO"]
[null,null,"MARZO"]
[null,null,"ABRIL"]
[null,null,"MAYO"]
[null,null,"JUNIO"]
[null,null,"JULIO"]
[null,null,"AGOSTO"]
[null,null,"SEPTIEMBRE"]
[null,null,"OCTUBRE"]
[null,null,"NOVIEMBRE"]
[null,null,"DICIEMBRE"]
[]
[null,null,null,null,null,null,{"$f":"Tabla245[[#Totals],[SINIESTROS VIALES CON DIAS DE INCAPACIDAD]]","v":0},{"$f":"Tabla245[[#Totals],[SINIESTROS VIALES MORTALES]]","v":0},{"$f":"Tabla245[[#Totals],[TOTAL DE SINIESTROS VIALES (SV)]]","v":0},{"$f":"Tabla245[[#Totals],[DIAS DE INCAPACIDAD POR SINIESTROS VIALES]]","v":0},{"$f":"Tabla245[[#Totals],[INDICE DE FRECUENCIA]]","v":0},{"$f":"Tabla245[[#Totals],[INDICE DE SEVERIDAD]]","v":0},null,null,{"$f":"Tabla245[[#Totals],[indicador 1]]","v":0},null,{"$f":"Tabla245[[#Totals],[indicador 2]]","v":0},null,null,{"$f":"Tabla245[[#Totals],[indicador 4]]","v":0},{"$f":"IFERROR((Tabla245[[#Totals],[Indicador 5]]),\"0%\")","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 6]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 7]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 8]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 9]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 10]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 11]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 12]]","v":0},null,{"$f":"Tabla245[[#Totals],[Indicador 13]]","v":0}]
[]
[null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[]
[null,null,null,null,null,null,null,"\nEn el periodo seleccionado se presentaron                    siniestros viales \n\nCon                dias de incapacidad laboral ",null,null,null,null,null,null,null,null,null,null,"Por cada 100 trabajadores  se presentan             siniestros viales en el periodo seleccionado.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Por cada 100 trabajadores se presentan                dias de  ausentismo por   siniestros viales en el periodo seleccionado."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"INDICADOR 1",null,null,null,null,null,null,null,null,null,null,"INDICADOR 2",null,null,null,null,null,null,null,"INDICADOR 3",null,null,null,null,"INDICADOR 3.1"]
[null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL ANUAL"]
[]
[null,null,null,null,null,null,null,"\nEn el periodo seleccionado se presentaron                     siniestros viales \n\npor cada 1'000.000 de Kilometros recorridos\n\n\n\n",null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado se presentaron               Siniestros viales\n\n\nLa sumatoria de costos directos e indirectos  causados por el o los siniestros viales en el periodo seleccionado ascienden a   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDICADOR 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nAl inicio de año se identifican             riegos de seguridad vial.\n\nAl final de año en el mismo perido se identifican              riesgos de seguridad vial.\n\n\n"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDICADOR 3.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nAl inicio de año se identifican            riegos criticos de seguridad vial.\n\nAl final de año en el mismo perido se identifican            riesgos criticos de seguridad vial\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"INDICADOR 4",null,null,null,null,null,null,null,null,null,null,"INDICADOR 5",null,null,null,null,null,null,null,"INDICADOR 6"]
[null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Muy mal ",20]
[null,null,null,null,null,null,null,"En el periodo seleccionado se da cumplimiento con el                 de las metas propuestas para el Plan estrategico de seguridad vial",null,null,null,null,null,"Mal",20,null,null,null,"En el periodo seleccionado se da cumplimiento con el                 de las actividades propuestas en el plan de trabajo, para el Plan estrategico de seguridad vial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado se realiza comparación para verificar si se cumple con la meta establecida en color verde, el porcentaje de exceso de jornadas laborales en la organización es de es de                  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Regular",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bueno",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Muy bueno",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",100]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor",{"$f":"U24*100","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Antes",{"$f":"O77-O80/2","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"puntero",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Despues",{"$f":"SUM(O69:O74)-O79-O80","v":199}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"INDICADOR 7",null,null,null,null,null,null,null,null,null,null,"INDICADOR 8",null,null,null,null,null,null,null,"INDICADOR 9"]
[null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[]
[null,null,null,null,null,null,null,"En el periodo seleccionado se realiza comparación para verificar si se cumple con la meta establecida en color verde, el porcentaje de cobertura del progama de gestión de velocidad es de                  ",null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado se realiza comparación para verificar si se cumple con la meta establecida en color verde, el porcentaje de excesos de velocidad  en la organización es de              ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado, las inspecciones propuestas de pre operacionales a vehiculos,  se ejucuta el               para dar cumplimeinto a la meta establecida."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"INDICADOR 10",null,null,null,null,null,null,null,null,null,null,"INDICADOR 11",null,null,null,null,null,null,null,"INDICADOR 12"]
[null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[]
[null,null,null,null,null,null,null,"En el periodo seleccionado se realiza comparación para verificar si se cumple con la meta establecida en color verde, el porcentaje de cumplimiento de los mantenimientos preventivos  realizados  a los vehiculos  es de                 ",null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado se realiza comparación para verificar si se cumple con la meta establecida en color verde, el porcentaje de cumplimiento en el plan de formación de la organización es de                  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado, las inspecciones propuestas de pre operacionales a vehiculos,  se ejucuta el               para dar cumplimeinto a la meta establecida."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDICADOR 13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En el periodo seleccionado, se realiza cierre  del             ,  de las No conformidades abiertas    para dar cumplimeinto a la meta establecida."]

{"sheet":"MATRIZ DE OBJETIVOSINDICADORES","index":3,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,3,0,8],[1,3,4,8],[5,3,6,8],[7,4,7,5],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[1,2,6,2],[8,10,9,10],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,10,11,10],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,5],[14,6,15,6],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,5],[12,6,13,6],[14,7,15,7],[14,8,15,8],[14,10,15,10],[14,11,15,11],[14,12,15,21],[14,22,15,22],[12,8,13,8],[12,10,13,10],[12,11,13,11],[12,12,13,21],[12,22,13,22],[12,7,13,7],[16,8,17,8],[16,10,17,10],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[18,10,19,10],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,5,17,5],[16,6,17,6],[16,7,17,7],[20,8,21,8],[20,10,21,10],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,5,23,5],[22,6,23,6],[22,7,23,7],[22,8,23,8],[22,10,23,10],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,5,21,5],[20,6,21,6],[20,7,21,7],[24,8,25,8],[24,10,25,10],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[26,10,27,10],[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,5,25,5],[24,6,25,6],[24,7,25,7],[28,8,29,8],[28,10,29,10],[30,1,31,1],[30,2,31,2],[30,3,31,3],[30,5,31,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[30,10,31,10],[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,5,29,5],[28,6,29,6],[28,7,29,7],[32,8,33,8],[32,10,33,10],[34,1,35,1],[34,2,35,2],[34,3,35,3],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[34,10,35,10],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,5,33,5],[32,6,33,6],[32,7,33,7]]}
[]
[null,null,{"$error":"#VALUE!"},"PLAN ESTRATEGICO DE SEGURIDAD VIAL",null,null,null,null,null,null,"# de Kms recorridos"]
[]
[null,null,null,null,null,null,null,null,null,null,"# Dias trabajados"]
[]
[null,null,null,"MATRIZ DE OBJETIVOS METAS E INDICADORES ",null,null,null,null,null,null,"# de Trabajadores"]
[]
[null,"#","OBJETIVO DEL INDICADOR","INDICADOR ","FORMULA",null,"META 2024","UNIDAD DE MEDIDA","PERIODO O FRECUENCIA","MAYOR ES MEJOR","RESPONSABLE","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[null,1]
[]
[null,2]
[]
[null,3]
[]
[null,"3.1"]
[]
[null,4]
[]
[null,5]
[]
[null,6]
[]
[null,7]
[]
[null,8]
[]
[null,9]
[]
[null,10]
[]
[null,11]
[]
[null,12]
[]
[null,13]

{"sheet":"INDICADORES MTO","index":4,"n_rows":57,"n_cols":27,"rows_kept":57,"cut":false,"hidden":false,"merged":[[15,10,34,26],[36,10,53,26],[56,10,60,26],[11,15,11,20],[11,21,11,26],[12,1,12,2],[12,3,12,8],[12,9,12,14],[12,15,12,20],[12,21,12,26],[8,25,8,26],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,25,9,26],[10,0,12,0],[10,1,10,2],[10,3,10,8],[10,9,10,14],[10,15,10,20],[10,21,10,26],[11,1,11,2],[11,3,11,8],[11,9,11,14],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,24],[7,13,7,14],[7,15,7,16],[7,17,7,18],[7,19,7,20],[7,21,7,22],[7,23,7,24],[8,19,8,20],[8,21,8,22],[8,23,8,24],[6,35,7,48],[7,0,9,0],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[6,11,6,12],[6,13,6,14],[6,15,6,16],[6,17,6,18],[6,19,6,20],[6,21,6,22],[7,25,7,26],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[5,21,5,22],[5,23,5,24],[5,25,5,26],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,23,6,24],[6,25,6,26],[4,0,6,0],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,23,4,24],[4,25,4,26],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[4,11,4,12],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[5,17,5,18],[5,19,5,20],[0,0,1,26],[2,0,3,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,25,2,26]]}
[2024]
[]
["ITEM",null,null,"ENE",null,"FEB",null,"MAR",null,"ABR",null,"MAY",null,"JUN",null,"JUL",null,"AGO",null,"SEP",null,"OCT",null,"NOV",null,"DIC"]
[null,null,null,"P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E","P","E"]
["META 1"]
[]
[null,null,null,{"$f":"IFERROR(D6/D5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(T6/T5,\"\")","v":""},null,{"$f":"IFERROR(V6/V5,\"\")","v":""},null,{"$f":"IFERROR(X6/X5,\"\")","v":""},null,{"$f":"IFERROR(Z6/Z5,\"\")","v":""}]
["META 2"]
[]
[null,null,null,{"$f":"IFERROR(D8/D9,\"\")","v":""},null,{"$f":"IFERROR(F8/F9,\"\")","v":""},null,{"$f":"IFERROR(H8/H9,\"\")","v":""},null,{"$f":"IFERROR(J8/J9,\"\")","v":""},null,{"$f":"IFERROR(L8/L9,\"\")","v":""},null,{"$f":"IFERROR(N8/N9,\"\")","v":""},null,{"$f":"IFERROR(P8/P9,\"\")","v":""},null,{"$f":"IFERROR(R8/R9,\"\")","v":""},null,{"$f":"IFERROR(T8/T9,\"\")","v":""},null,{"$f":"IFERROR(V8/V9,\"\")","v":""},null,{"$f":"IFERROR(X8/X9,\"\")","v":""},null,{"$f":"IFERROR(Z8/Z9,\"\")","v":""}]
["Meta 3"]
[]
[null,null,null,{"$f":"IFERROR(D11/D12,\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(J11/J12,\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(P11/P12,\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(V11/V12,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"ANALISIS TENDENCIAL"]

{"sheet":"ESTADISTICAS SINIESTROS","index":5,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,17,47,21],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[47,15,47,16],[45,17,45,21],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[46,17,46,21],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[45,15,45,16],[43,17,43,21],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[44,15,44,16],[44,17,44,21],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[43,15,43,16],[41,17,41,21],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[42,15,42,16],[42,17,42,21],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[41,15,41,16],[39,17,39,21],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[40,15,40,16],[40,17,40,21],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[37,17,37,21],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[38,17,38,21],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[35,17,35,21],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[36,15,36,16],[36,17,36,21],[33,11,34,12],[33,13,34,14],[33,15,34,16],[33,17,34,21],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[35,15,35,16],[29,18,29,19],[30,18,30,19],[32,2,32,21],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,6],[33,7,34,8],[33,9,34,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[28,18,28,19],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[27,15,27,16],[24,18,25,20],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[26,15,26,16],[26,18,26,19],[27,18,27,19],[22,2,23,16],[24,2,25,2],[24,4,25,4],[24,5,25,6],[24,7,25,8],[24,9,25,10],[24,11,25,12],[24,13,25,14],[24,15,25,16],[0,1,2,3],[0,4,1,19],[0,20,0,21],[1,20,1,21],[2,4,2,19],[2,20,2,21],[6,2,7,16],[6,17,7,21],[8,17,17,21]]}
[null,{"$error":"#VALUE!"},null,null,"PLAN ESTRATÉGICO DE SEGURIDAD VIAL"]
[]
[null,null,null,null,"REGISTRO Y ANALISIS ESTADÍSTICO DE SINIESTROS VIALES"]
[]
[]
[]
[null,null,"PIRÁMIDE DE LA SEGURIDAD VIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[]
[]
[null,null,null,null,"SINIESTROS VIALES","EVENTOS","%"]
[null,null,null,null,"Lesiones mortales o graves",0,{"$f":"IFERROR((F12/$F$16),\"0\")","v":"0"}]
[null,null,null,null,"Lesiones Leves",0,{"$f":"IFERROR((F13/$F$16),\"0\")","v":"0"}]
[null,null,null,null,"Daños Materiales",0,0]
[null,null,null,null,"Incidentes",0,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F12:F15)","v":0},{"$f":"SUM(G12:G15)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"MATRIZ DE NIVEL DE PERDIDA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulado"]
[null,null,"NIVEL",null,"VALOR","AFECTACIÓN APERSONAS",null,"AFECTACIÓN EN COSTOS",null,"AFECTACIÓN IMAGEN",null,"INVESTIGACIONES Y SANCIONES",null,"DAÑOS Y CONSECUENCIAS",null,"AFECTACIÓN AMBIENTAL",null,null,"SINIESTRALIDAD EMPRESA"]
[]
[null,null,4,null,"CRÍTICO","Muerte",null,"Mas de $100'.000.000",null,"Conocimientos en medios de comunicación a nivel internacional",null,"Investigaciones y sanciones criticas",null,"Volcamiento, incendio",null,"Contaminación ambiental severa",null,null,"CRÍTICO",null,0]
[null,null,3,null,"GRAVE","Incapacidad mas de 30 días",null,"Entre $10'.000.000 Y $100'.000.000",null,"Conocimientos en medios de comunicación a nivel nacional",null,"Investigaciones y sanciones medias",null,"Semivolcamiento, tijera",null,"Contaminación ambiental media",null,null,"GRAVE",null,0]
[null,null,2,null,"MEDIO","Incapacidad hasta 30 días",null,"Entre $1'.000.000 y $10'.000.000",null,"Conocimientos en medios de comunicación a nivel local",null,"Investigaciones y sanciones bajas",null,"Salida de la vía",null,"Contaminación ambiental Leve",null,null,"MEDIO",null,0]
[null,null,1,null,"LEVE","Primeros auxilios",null,"Menos de $1'.000.000",null,"Conocimiento en el sector o en el entorno de la empresa",null,"Quejas y reclamos / Errores humanos",null,"Choques simples",null,"Derrame controlado",null,null,"LEVE",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,0]
[]
[]
[null,"#","VALOR","FECHA","NOMBRE / DESCRIPCIÓN","AFECTACIÓN APERSONAS",null,"AFECTACIÓN EN COSTOS",null,"AFECTACIÓN IMAGEN",null,"INVESTIGACIONES Y SANCIONES",null,"DAÑOS Y CONSECUENCIAS",null,"AFECTACIÓN AMBIENTAL",null,"ANALISIS / PLAN DE ACCIÓN"]
[]
[null,1,null,null,null,{"$f":"IFERROR(VLOOKUP(C36,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(E36,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(G36,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(I36,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(K36,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(M36,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"}]
[null,2,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(E37,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(G37,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(I37,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(K37,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(M37,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"}]
[null,3,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(E38,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(G38,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(I38,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(K38,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(M38,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"}]
[null,4,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(E39,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(G39,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(I39,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(K39,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(M39,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"}]
[null,5,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(E40,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(G40,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(I40,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(K40,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(M40,$E$27:$Q$30,2,FALSE),\"-\")","v":"-"}]
[null,6,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C41,$E$27:$Q$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C41,$E$27:$Q$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C41,$E$27:$Q$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C41,$E$27:$Q$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C41,$E$27:$Q$30,12,FALSE),\"-\")","v":"-"}]
[null,7,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C42,$E$27:$Q$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C42,$E$27:$Q$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C42,$E$27:$Q$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C42,$E$27:$Q$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C42,$E$27:$Q$30,12,FALSE),\"-\")","v":"-"}]
[null,8,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C43,$E$27:$Q$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C43,$E$27:$Q$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C43,$E$27:$Q$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C43,$E$27:$Q$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C43,$E$27:$Q$30,12,FALSE),\"-\")","v":"-"}]
[null,9,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C44,$D$27:$P$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C44,$D$27:$P$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C44,$D$27:$P$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C44,$D$27:$P$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C44,$D$27:$P$30,12,FALSE),\"-\")","v":"-"}]
[null,10,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C45,$D$27:$P$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C45,$D$27:$P$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C45,$D$27:$P$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C45,$D$27:$P$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C45,$D$27:$P$30,12,FALSE),\"-\")","v":"-"}]
[null,11,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C46,$D$27:$P$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C46,$D$27:$P$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C46,$D$27:$P$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C46,$D$27:$P$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C46,$D$27:$P$30,12,FALSE),\"-\")","v":"-"}]
[null,11,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C47,$D$27:$P$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C47,$D$27:$P$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C47,$D$27:$P$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C47,$D$27:$P$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C47,$D$27:$P$30,12,FALSE),\"-\")","v":"-"}]
[null,11,null,null,null,"-",null,{"$f":"IFERROR(VLOOKUP(C48,$D$27:$P$30,4,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C48,$D$27:$P$30,6,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C48,$D$27:$P$30,8,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C48,$D$27:$P$30,10,FALSE),\"-\")","v":"-"},null,{"$f":"IFERROR(VLOOKUP(C48,$D$27:$P$30,12,FALSE),\"-\")","v":"-"}]

{"sheet":"CARACTERIZACIÓN","index":6,"n_rows":192,"n_cols":25,"rows_kept":192,"cut":false,"hidden":false,"merged":[[0,1,2,3],[4,2,4,4],[2,23,2,24],[116,1,116,8],[116,10,116,15],[118,1,118,4],[118,6,118,8],[118,10,126,15],[119,6,119,8],[120,6,120,8],[121,6,121,8],[122,6,122,8],[123,6,123,8],[124,6,124,8],[125,6,125,8],[126,1,126,4],[126,6,126,8],[64,10,77,15],[65,6,65,8],[66,6,66,8],[67,6,67,8],[68,6,68,8],[69,6,69,8],[70,6,70,8],[29,10,33,15],[62,1,62,8],[62,10,62,15],[47,6,47,8],[38,1,38,4],[38,6,38,8],[39,1,39,4],[39,6,39,8],[40,1,40,4],[40,6,40,8],[35,1,35,8],[35,10,35,15],[43,1,43,8],[43,10,43,15],[45,1,45,4],[45,6,45,8],[46,6,46,8],[51,6,51,8],[56,6,56,8],[58,1,58,4],[58,6,58,8],[37,1,37,4],[37,6,37,8],[48,6,48,8],[191,6,191,8],[181,6,181,8],[182,6,182,8],[183,6,183,8],[184,6,184,8],[185,6,185,8],[186,6,186,8],[187,6,187,8],[188,6,188,8],[189,6,189,8],[190,6,190,8],[154,6,154,8],[155,6,155,8],[57,6,57,8],[71,6,71,8],[72,6,72,8],[191,1,191,4],[178,1,178,8],[160,1,160,4],[163,1,163,8],[92,6,92,8],[93,6,93,8],[94,6,94,8],[95,6,95,8],[178,10,178,15],[180,1,180,4],[180,6,180,8],[180,10,191,15],[166,6,166,8],[175,6,175,8],[167,6,167,8],[168,6,168,8],[169,6,169,8],[170,6,170,8],[171,6,171,8],[172,6,172,8],[173,6,173,8],[174,6,174,8],[175,1,175,4],[131,1,131,4],[140,1,140,4],[129,1,129,8],[129,10,129,15],[163,10,163,15],[165,10,175,15],[165,1,165,4],[165,6,165,8],[160,6,160,8],[156,6,156,8],[157,6,157,8],[158,6,158,8],[159,6,159,8],[143,1,143,8],[143,10,143,15],[145,10,160,15],[145,6,145,8],[146,6,146,8],[147,6,147,8],[148,6,148,8],[149,6,149,8],[150,6,150,8],[151,6,151,8],[152,6,152,8],[153,6,153,8],[145,1,145,4],[29,6,29,8],[32,6,32,8],[31,6,31,8],[30,6,30,8],[131,10,140,15],[131,6,131,8],[132,6,132,8],[133,6,133,8],[134,6,134,8],[135,6,135,8],[136,6,136,8],[137,6,137,8],[138,6,138,8],[139,6,139,8],[140,6,140,8],[87,6,87,8],[88,6,88,8],[89,6,89,8],[90,6,90,8],[91,6,91,8],[73,6,73,8],[49,6,49,8],[50,6,50,8],[74,6,74,8],[75,6,75,8],[76,6,76,8],[64,1,64,4],[98,1,98,8],[113,1,113,4],[109,6,109,8],[110,6,110,8],[111,6,111,8],[112,6,112,8],[113,6,113,8],[100,1,100,4],[101,6,101,8],[102,6,102,8],[103,6,103,8],[77,1,77,4],[98,10,98,15],[100,10,113,15],[104,6,104,8],[105,6,105,8],[106,6,106,8],[107,6,107,8],[108,6,108,8],[80,10,80,15],[86,1,86,4],[87,1,87,4],[88,1,88,4],[89,1,89,4],[90,1,90,4],[91,1,91,4],[92,1,92,4],[93,1,93,4],[82,10,95,15],[83,6,83,8],[83,1,83,4],[84,1,84,4],[85,1,85,4],[100,6,100,8],[32,2,32,4],[0,23,0,24],[1,23,1,24],[1,4,2,22],[0,4,0,22],[82,1,82,4],[95,1,95,4],[29,1,29,4],[22,1,23,1],[22,5,23,7],[52,6,52,8],[53,6,53,8],[82,6,82,8],[84,6,84,8],[85,6,85,8],[86,6,86,8],[54,6,54,8],[55,6,55,8],[27,10,27,15],[27,1,27,8],[80,1,80,8],[64,6,64,8],[94,1,94,4],[77,6,77,8]]}
[null,{"$error":"#VALUE!"},null,null,"PLAN ESTRATEGICO DE SEGURIDAD VIAL"]
[null,null,null,null,"CARACTERIZACIÓN DE LA ACCIDENTALIDAD VIAL ________"]
[]
[]
[null,"NOMBRE","FECHA",null,null,"HORA (0-23)","EVENTO ","DIA DE LA SEMANA","RUTA","TIPO DE VEHÍCULO","OFICIO ","PROPIO / TERCERO","TIEMPO DE CONDUCCIÓN","MECANISMO","PARTE DEL CUERPO AFECTADA","TIPO DE LESIÓN","AGENTE","SINIESTROS VIALES SIN INCAPACIDAD","SINIESTROS VIALES CON INCAPACIDAD","No. DÍAS DE INCAPACIDAD ","ACCIDENTE MORTAL  ","NÚMERO DE VÍCTIMAS","ACCIDENTE AFECTA A TERCEROS (COMUNIDAD)","COSTOS ESTIMADOS DEL SINIESTRO VIAL","ACCIONES REALIZADAS DESPUÉS DEL EVENTO"]
[]
[]
["x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T6:T18)","v":0},{"$f":"SUM(U6:U18)","v":0}]
[]
[]
[]
[null,"ACCIDENTES MORTALES",null,null,null,"DÍAS DE INCAPACIDAD"]
[]
[]
[]
[null,"Las siguientes tablas están formuladas, genera los datos de forma automática con los datos ingresados en la tabla superior"]
[null,"ACCIDENTALIDAD POR EMPRESA O CONTRATISTA",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"A.T.  POR EMPRESA / CONTRATISTA",null,null,null,"No. CASOS","%"]
[null,"PROPIO",null,null,null,{"$f":"COUNTIF(L6:L18,B31)","v":0},{"$f":"IFERROR((F31/F33),\"\")","v":""}]
[null,"TERCERO",null,null,null,{"$f":"COUNTIF(L6:L18,B32)","v":0},{"$f":"IFERROR((F32/F33),\"\")","v":""}]
[null,null,"TOTAL",null,null,{"$f":"SUM(F31:F32)","v":0},{"$f":"SUM(G31:I32)","v":0}]
[]
[]
[null,"SINIESTRALIDAD VIAL",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"SINIESTRALIDAD VIAL",null,null,null,"DÍAS","%"]
[null,"SINIESTRO VIAL SIN INCAPACIDAD",null,null,null,{"$f":"COUNTIF((R6:R18),\"X\")","v":0},{"$f":"IFERROR((F39/F41),\"\")","v":""}]
[null,"SINIESTRO VIAL CON DÍAS DE INCAPACIDAD",null,null,null,{"$f":"COUNTIF((S6:S18),\"X\")","v":0},{"$f":"IFERROR((F40/F41),\"\")","v":""}]
[null,"TOTAL",null,null,null,{"$f":"SUM(F39:F40)","v":0},{"$f":"SUM(G39:I40)","v":0}]
[]
[]
[null,"TIPO DE VEHÍCULO",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"TIPO DE VEHÍCULO",null,null,null,"No. CASOS","%"]
[null,"Patineta eléctrica",null,null,null,{"$f":"COUNTIF(J6:J18,B47)","v":0},{"$f":"IFERROR((F47/$F$59),\"\")","v":""}]
[null,"Bicicleta",null,null,null,{"$f":"COUNTIF(J6:J18,B48)","v":0},""]
[null,"Motocicleta",null,null,null,{"$f":"COUNTIF(J6:J18,B49)","v":0},""]
[null,"Motocarro",null,null,null,{"$f":"COUNTIF(J6:J18,B50)","v":0},""]
[null,"Automóvil",null,null,null,{"$f":"COUNTIF(J6:J18,B51)","v":0},""]
[null,"Camioneta",null,null,null,{"$f":"COUNTIF(J6:J18,B52)","v":0},""]
[null,"Bus ",null,null,null,{"$f":"COUNTIF(J6:J18,B53)","v":0},""]
[null,"Buseta",null,null,null,{"$f":"COUNTIF(J6:J18,B54)","v":0},""]
[null,"Camión",null,null,null,{"$f":"COUNTIF(J6:J18,B55)","v":0},""]
[null,"Volqueta",null,null,null,{"$f":"COUNTIF(J6:J18,B56)","v":0},""]
[null,"Tractocamión",null,null,null,{"$f":"COUNTIF(J6:J18,B57)","v":0},""]
[null,"Otro",null,null,null,{"$f":"COUNTIF(J6:J18,B58)","v":0},""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F47:F58)","v":0},{"$f":"SUM(G47:I58)","v":0}]
[]
[]
[]
[null,"DÍAS DE INCAPACIDAD",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"MES",null,null,null,"# DÍAS","%","GRAFICA"]
[null,"ENERO",null,null,null,{"$f":"SUMIF(D6:D18,B66,T6:T18)","v":0},{"$f":"IFERROR((F66/$F$78),\"\")","v":""},{"$f":"G66","v":""}]
[null,"FEBRERO",null,null,null,{"$f":"SUMIF(D6:D18,B67,T6:T18)","v":0},{"$f":"IFERROR((F67/$F$78),\"\")","v":""},{"$f":"G67","v":""}]
[null,"MARZO",null,null,null,{"$f":"SUMIF(D6:D18,B68,T6:T18)","v":0},{"$f":"IFERROR((F68/$F$78),\"\")","v":""},""]
[null,"ABRIL",null,null,null,{"$f":"SUMIF(D6:D18,B69,T6:T18)","v":0},"",""]
[null,"MAYO",null,null,null,{"$f":"SUMIF(D6:D18,B70,T6:T18)","v":0},"",""]
[null,"JUNIO",null,null,null,{"$f":"SUMIF(D6:D18,B71,T6:T18)","v":0},"",""]
[null,"JULIO",null,null,null,{"$f":"SUMIF(D6:D18,B72,T6:T18)","v":0},"",""]
[null,"AGOSTO",null,null,null,{"$f":"SUMIF(D6:D18,B73,T6:T18)","v":0},"",""]
[null,"SEPTIEMBRE",null,null,null,{"$f":"SUMIF(D6:D18,B74,T6:T18)","v":0},"",""]
[null,"OCTUBRE",null,null,null,{"$f":"SUMIF(D6:D18,B75,T6:T18)","v":0},"",""]
[null,"NOVIEMBRE",null,null,null,{"$f":"SUMIF(D6:D18,B76,T6:T18)","v":0},"",""]
[null,"DICIEMBRE",null,null,null,{"$f":"SUMIF(D6:D18,B77,T6:T18)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F66:F77)","v":0},{"$f":"SUM(G66:G77)","v":0}]
[]
[]
[null,"ACCIDENTES POR MES",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"MES",null,null,null,"No. CASOS","%","GRAFICA"]
[null,"ENERO",null,null,null,{"$f":"COUNTIF(D6:D18,B84)","v":0},{"$f":"IFERROR((F84/$F$96),\"\")","v":""},{"$f":"G84","v":""}]
[null,"FEBRERO",null,null,null,{"$f":"COUNTIF(D6:D18,B85)","v":0},{"$f":"IFERROR((F85/$F$96),\"\")","v":""},{"$f":"G85","v":""}]
[null,"MARZO",null,null,null,{"$f":"COUNTIF(D6:D18,B86)","v":0},"",""]
[null,"ABRIL",null,null,null,{"$f":"COUNTIF(D6:D18,B87)","v":0},"",""]
[null,"MAYO",null,null,null,{"$f":"COUNTIF(D6:D18,B88)","v":0},"",""]
[null,"JUNIO",null,null,null,{"$f":"COUNTIF(D6:D18,B89)","v":0},"",""]
[null,"JULIO",null,null,null,{"$f":"COUNTIF(D6:D18,B90)","v":0},"",""]
[null,"AGOSTO",null,null,null,{"$f":"COUNTIF(D6:D18,B91)","v":0},"",""]
[null,"SEPTIEMBRE",null,null,null,{"$f":"COUNTIF(D6:D18,B92)","v":0},"",""]
[null,"OCTUBRE",null,null,null,{"$f":"COUNTIF(D6:D18,B93)","v":0},"",""]
[null,"NOVIEMBRE",null,null,null,{"$f":"COUNTIF(D6:D18,B94)","v":0},"",""]
[null,"DICIEMBRE",null,null,null,{"$f":"COUNTIF(D6:D18,B95)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F84:F95)","v":0},{"$f":"SUM(G84:G95)","v":0}]
[]
[]
[null,"PARTE DEL CUERPO AFECTADA",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"PARTE DEL CUERPO AFECTADA",null,null,null,"No. CASOS","%","GRAFICA"]
[null,"CABEZA",null,null,null,{"$f":"COUNTIF(O6:O18,B102)","v":0},{"$f":"IFERROR((F102/$F$114),\"\")","v":""},{"$f":"G102","v":""}]
[null,"OJO",null,null,null,{"$f":"COUNTIF(O6:O18,B103)","v":0},{"$f":"IFERROR((F103/$F$114),\"\")","v":""},{"$f":"G103","v":""}]
[null,"CUELLO",null,null,null,{"$f":"COUNTIF(O6:O18,B104)","v":0},"",""]
[null,"TRONCO (Incluye espalda, columna vertebral, médula espinal, pelvis)",null,null,null,{"$f":"COUNTIF(O6:O18,B105)","v":0},"",""]
[null,"TÓRAX",null,null,null,{"$f":"COUNTIF(O6:O18,B106)","v":0},"",""]
[null,"ABDOMEN",null,null,null,{"$f":"COUNTIF(O6:O18,B107)","v":0},"",""]
[null,"MIEMBROS SUPERIORES",null,null,null,{"$f":"COUNTIF(O6:O18,B108)","v":0},"",""]
[null,"MANOS",null,null,null,{"$f":"COUNTIF(O6:O18,B109)","v":0},"",""]
[null,"MIEMBROS INFERIORES",null,null,null,{"$f":"COUNTIF(O6:O18,B110)","v":0},"",""]
[null,"PIES",null,null,null,{"$f":"COUNTIF(O6:O18,B111)","v":0},"",""]
[null,"LESIONES MÚLTIPLES",null,null,null,{"$f":"COUNTIF(O6:O18,B112)","v":0},"",""]
[null,"LESIONES GENERALES U OTRAS",null,null,null,{"$f":"COUNTIF(O6:O18,B113)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F102:F113)","v":0},{"$f":"SUM(G102:G113)","v":0}]
[]
[]
[null,"HORA DEL ACCIDENTE",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"HORA DEL ACCIDENTE",null,null,null,"No. CASOS","%","GRAFICA"]
[null,"LUNES",null,null,null,{"$f":"COUNTIF(H6:H18,B120)","v":0},{"$f":"IFERROR((F120/$F$127),\"\")","v":""},{"$f":"G120","v":""}]
[null,"MARTES",null,null,null,{"$f":"COUNTIF(H6:H18,B121)","v":0},"",{"$f":"G121","v":""}]
[null,"MIERCOLES",null,null,null,{"$f":"COUNTIF(H6:H18,B122)","v":0},"",""]
[null,"JUEVES",null,null,null,{"$f":"COUNTIF(H6:H18,B123)","v":0},"",""]
[null,"VIERNES",null,null,null,{"$f":"COUNTIF(H6:H18,B124)","v":0},"",""]
[null,"SABADO",null,null,null,{"$f":"COUNTIF(H6:H18,B125)","v":0},"",""]
[null,"DOMINGO",null,null,null,{"$f":"COUNTIF(H6:H18,B126)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F120:F126)","v":0},{"$f":"SUM(G120:G126)","v":0}]
[]
[]
[null,"HORA DEL ACCIDENTE",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"HORA DEL ACCIDENTE",null,null,null,"No. CASOS","%","GRAFICA"]
[null,"ENTRE LAS 0 Y 3:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B133)","v":0},{"$f":"IFERROR((F133/$F$141),\"\")","v":""},{"$f":"G133","v":""}]
[null,"DE LAS 3:00 A LAS 6:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B134)","v":0},{"$f":"IFERROR((F134/$F$141),\"\")","v":""},{"$f":"G134","v":""}]
[null,"DE LAS 6:00 A LAS 9:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B135)","v":0},"",""]
[null,"DE LAS 9:00 A LAS 12:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B136)","v":0},"",""]
[null,"DE LAS 12:00 A LAS 15:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B137)","v":0},"",""]
[null,"DE LAS 15:00 A LAS 18:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B138)","v":0},"",""]
[null,"DE LAS 18:00 A LAS 21:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B139)","v":0},"",""]
[null,"DE LAS 21:00 A LAS 24:00 ",null,null,null,{"$f":"COUNTIF(F6:F18,B140)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F133:F140)","v":0},{"$f":"SUM(G133:G140)","v":0}]
[]
[]
[null,"LESIÓN O DAÑO APARENTE",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"LESIÓN O DAÑO APARENTE",null,null,null,"No. CASOS","%"]
[null,"FRACTURA",null,null,null,{"$f":"COUNTIF(P6:P18,B147)","v":0},{"$f":"IFERROR((F147/$F$161),\"\")","v":""},{"$f":"G147","v":""}]
[null,"LUXACIÓN",null,null,null,{"$f":"COUNTIF(P6:P18,B148)","v":0},{"$f":"IFERROR((F148/$F$161),\"\")","v":""},{"$f":"G148","v":""}]
[null,"TORCEDURA, ESGUINCE, DESGARRO MUSCULAR, HERNIA O LACERACIÓN DE MÚSCULO O TENDÓN SIN HERIDA",null,null,null,{"$f":"COUNTIF(P6:P18,B149)","v":0},"",""]
[null,"CONMOCIÓN O TRAUMA INTERNO",null,null,null,{"$f":"COUNTIF(P6:P18,B150)","v":0},"",""]
[null,"AMPUTACIÓN O ENUCLEACIÓN (Exclusión o pérdida del ojo)",null,null,null,{"$f":"COUNTIF(P6:P18,B151)","v":0},"",""]
[null,"HERIDA",null,null,null,{"$f":"COUNTIF(P6:P18,B152)","v":0},"",""]
[null,"TRAUMA SUPERFICIAL (Incluye rasguño, punzón o pinchazo y lesión en ojo por cuerpo extraño)",null,null,null,{"$f":"COUNTIF(P6:P18,B153)","v":0},"",""]
[null,"GOLPE O CONTUSIÓN O APLASTAMIENTO",null,null,null,{"$f":"COUNTIF(P6:P18,B154)","v":0},"",""]
[null,"QUEMADURA",null,null,null,{"$f":"COUNTIF(P6:P18,B155)","v":0},"",""]
[null,"ENVENENAMIENTO O INTOXICACIÓN AGUDA O ALERGIA",null,null,null,{"$f":"COUNTIF(P6:P18,B156)","v":0},"",""]
[null,"EFECTO DEL TIEMPO, DEL CLIMA U OTRO RELACIONADO CON EL AMBIENTE",null,null,null,{"$f":"COUNTIF(P6:P18,B157)","v":0},"",""]
[null,"ASFIXIA",null,null,null,{"$f":"COUNTIF(P6:P18,B158)","v":0},"",""]
[null,"EFECTO NOCIVO DE LA RADIACIÓN ",null,null,null,{"$f":"COUNTIF(P6:P18,B159)","v":0},"",""]
[null,"LESIONES MÚLTIPLES",null,null,null,{"$f":"COUNTIF(P6:P18,B160)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F147:F160)","v":0},{"$f":"SUM(G147:G160)","v":0}]
[]
[]
[null,"MECANISMO O FORMA DEL ACCIDENTE",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"MECANISMO O FORMA DEL ACCIDENTE",null,null,null,"No. CASOS","%"]
[null,"CAÍDA DE PERSONAS",null,null,null,{"$f":"COUNTIF(N6:N18,B167)","v":0},{"$f":"IFERROR((F167/$F$176),\"\")","v":""},{"$f":"G167","v":""}]
[null,"CAÍDA DE OBJETOS",null,null,null,{"$f":"COUNTIF(N6:N18,B168)","v":0},{"$f":"IFERROR((F168/$F$176),\"\")","v":""},{"$f":"G168","v":""}]
[null,"PISADAS, CHOQUES O GOLPES",null,null,null,{"$f":"COUNTIF(N6:N18,B169)","v":0},"",""]
[null,"ATRAPAMIENTOS",null,null,null,{"$f":"COUNTIF(N6:N18,B170)","v":0},"",""]
[null,"SOBRE ESFUERZO, ESFUERZO EXCESIVO O FALSO MOVIMIENTO",null,null,null,{"$f":"COUNTIF(N6:N18,B171)","v":0},"",""]
[null,"EXPOSICIÓN O CONTACTO CON TEMPERATURA EXTREMA",null,null,null,{"$f":"COUNTIF(N6:N18,B172)","v":0},"",""]
[null,"EXPOSICIÓN O CONTACTO CON ELECTRICIDAD",null,null,null,{"$f":"COUNTIF(N6:N18,B173)","v":0},"",""]
[null,"EXPOSICIÓN O CONTACTO CON SUSTANCIAS NOCIVAS O RADIACIONES O SALPICADURAS",null,null,null,{"$f":"COUNTIF(N6:N18,B174)","v":0},"",""]
[null,"OTRO",null,null,null,{"$f":"COUNTIF(N6:N18,B175)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F167:F175)","v":0},1]
[]
[]
[null,"AGENTE DEL ACCIDENTE",null,null,null,null,null,null,null,null,"ANÁLISIS"]
[]
[null,"AGENTE DEL ACCIDENTE",null,null,null,"No. CASOS","%"]
[null,"MAQUINAS Y/O EQUIPOS",null,null,null,{"$f":"COUNTIF(Q6:Q18,B182)","v":0},{"$f":"IFERROR((F182/$F$192),\"\")","v":""},{"$f":"G182","v":""}]
[null,"MEDIOS DE TRANSPORTE",null,null,null,{"$f":"COUNTIF(Q6:Q18,B183)","v":0},{"$f":"IFERROR((F183/$F$192),\"\")","v":""},{"$f":"G183","v":""}]
[null,"APARATOS",null,null,null,{"$f":"COUNTIF(Q6:Q18,B184)","v":0},"",""]
[null,"HERRAMIENTAS, IMPLEMENTOS O UTENSILIOS",null,null,null,{"$f":"COUNTIF(Q6:Q18,B185)","v":0},"",""]
[null,"MATERIALES O SUSTANCIAS",null,null,null,{"$f":"COUNTIF(Q6:Q18,B186)","v":0},"",""]
[null,"RADIACIONES",null,null,null,{"$f":"COUNTIF(Q6:Q18,B187)","v":0},"",""]
[null,"AMBIENTE DE TRABAJO (Incluye superficies de tránsito y de trabajo, muebles, tejados, en el exterior, interior o subterráneos.",null,null,null,{"$f":"COUNTIF(Q6:Q18,B188)","v":0},"",""]
[null,"ANIMALES (Vivos o productos animales)",null,null,null,{"$f":"COUNTIF(Q6:Q18,B189)","v":0},"",""]
[null,"OTROS AGENTES NO CLASIFICADOS",null,null,null,{"$f":"COUNTIF(Q6:Q18,B190)","v":0},"",""]
[null,"AGENTES NO CLASIFICADOR POR FALTA DE DATOS",null,null,null,{"$f":"COUNTIF(Q6:Q18,B191)","v":0},"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F182:F191)","v":0},{"$f":"SUM(G182:G191)","v":0}]